
create external table jms_dim.dim_sys_customer_entity_relation_base
(
    entity_code    string comment '店铺实体编码',
    customer_code  string comment '客户(店铺)编号',
    create_time    timestamp comment '创建时间',
    create_by_code string comment '创建人code',
    create_by_name string comment '创建人名称'
)
comment '实体店铺关联表'

    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dim.db/external/dim_sys_customer_entity_relation_base';